Using the SAS Add-in for Microsoft Office, if you attempt to open any table from a library that contains an indexed dataset as well as an extra variable defined in metadata that doesn't exist physically on the table, then you will receive an exception when you select the library. The exception reads as follows:

System.Data.OleDb.OleDbException: An error has
occurred.
 at System.Data.OleDb.OleDbDataReader.PorcessResults(Int32 hr)
 at System.Data.OleDb.OleDbDataReader.GetRowHandles()
 at System.Data.OleDb.OleDbDataReader.ReadRowset()
 at System.Data.OleDb.OleDbDataReader.Read()
 at System.Data.OleDb.OleDbDataReader.HasRowsRead()
 at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behavior, String method)
 at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
 at SAS.DatasetOpenDialog.Library.BuildFullList()  

If you select OK on the exception, you can still select any table in the library, except the table that you created with the extra column in metadata. If you attempt to open the table with the extra metadata column, you will receive a message similar to the following:

Column z is not on file library.tblename 

To circumvent this problem opening the table, remove the extra column in the metadata or create a physical column that matches the metadata column.

Operating System and Release Information